ORACLE_HOME
Location of ORACLE_HOME for full client only. Instant client should leave it blank.
DYLD_LIBRARY_PATH
Location of the path which contains Oracle libraries for instant client and SQL*Plus (e.g. ORACLE_HOME/lib). Always required.
User bundled instant client
Checks this option to use the Oracle Instant Client included in Navicat installation folder.
Oracle Instant Client is the simplest way to deploy a full Oracle Client application built with OCI, OCCI, JDBC-OCI, or ODBC drivers. It provides the necessary Oracle Client libraries in a small set of files. It provides the necessary Oracle Client libraries in a small set of files. It has already included in Navicat installation folder. You can also download Oracle Client / Oracle Instant Client through -
Downloading
Oracle Client
http://www.oracle.com/technology/software/products/database/index.htmlOracle Instant Client
http://www.oracle.com/technology/software/tech/oci/instantclient/index.html
Hint: MAC OS X any versions running on PPC cpu should use PPC Navicat and PPC Instant Client. MAC OS X 10.4 or below running on INTEL cpu should use PPC Navicat and PPC Instant Client. MAC OS X 10.5 or above running on INTEL cpu should use X86 Navicat and x86 Instant Client. Installation Guide
Oracle Client for Mac OS X on Intel x86
http://download.oracle.com/docs/cd/B19306_01/install.102/e12121/toc.htmOracle Instant Client
- Download the appropriate Instant Client packages for your platform. All installations REQUIRE the Basic or Basic Lite package.
- Just simply unzip the packages and copy all files under /usr/lib or ~/lib (not /usr/lib/instantclient/). (Copy all files under /usr/lib for Mac OS X 10.3, otherwise, copy all files under /usr/lib or ~/lib for Mac OS X 10.4 or above.)
TNS_ADMIN
Location of the tnsnames.ora file (e.g. ORACLE_HOME/network). It is optional. Required when using TNS connection.
Notes: To change the path settings, you need to click the lock and enter your OS username and password to unlock the control.
- If you lock the control back after changing the settings, a dialog will be prompted to ask whether you want to save the settings.
- If you click OK after changing the settings, it will just save without prompting any dialogs.
- If you wait until the lock timeout (300 seconds) after changing the settings, your changes will be reverted.